#!/bin/bash

read -p "please input database name:" u_dbname

mysql -uroot -p123123 <<EOF
create database $u_dbname;
show databases;
quit
EOF

echo "create database $u_dbname ok"
